/**
 * 
 */
package com.uuticketweb.ticket.manager.bean;

import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * @author stephen
 *
 */
public class PolicyClass {

	public static final String TABLE_NAME = "POLICY_CLASS";
	public static final String COLUMN_ID = "ID";
	public static final String COLUMN_CLASS_NAME = "CLASS_NAME";
	public static final String COLUMN_ROUTE_TYPE = "ROUTE_TYPE";
	public static final String COLUMN_DEPARTURE = "DEPARTURE";
	public static final String COLUMN_DESTINATION = "DESTINATION";
	public static final String COLUMN_PRICE = "PRICE";
	public static final String COLUMN_RT_OPEN = "RT_OPEN";
	public static final String COLUMN_CANCEL_FEE = "CANCEL_FEE";
	public static final String COLUMN_REFUND_FEE = "REFUND_FEE";
	public static final String COLUMN_POLICY_NO = "POLICY_NO";
	public static final String COLUMN_START_DATE = "START_DATE";
	public static final String COLUMN_END_DATE = "END_DATE";
	public static final String COLUMN_STAY_MIN = "STAY_MIN";
	public static final String COLUMN_STAY_MAX = "STAY_MAX";
	public static final String COLUMN_WEEKDAY = "WEEKDAY";
	public static final String COLUMN_PERSON_MIN = "PERSON_MIN";
	public static final String COLUMN_PERSON_MAX = "PERSON_MAX";
	public static final String COLUMN_FLIGHT_NO = "FLIGHT_NO";
	public static final String COLUMN_PRE_ORDER_DATES = "PRE_ORDER_DATES";
	public static final String COLUMN_CLASS_TYPE = "CLASS_TYPE";
	//public static final String COLUMN_LIMIT_RETURN_FLIGHT = "LIMIT_RETURN_FLIGHT";
	public static final String COLUMN_CARRIER_CODE = "CARRIER_CODE";

	private int id;
	private String className;
	private String routeType;
	private String departure;
	private String destination;
	private int price;
	private String rtOpen;
	private int cancelFee;
	private int refundFee;
	private String policyNO;
	private String startDate;
	private String endDate;
	private int stayMin;
	private int stayMax;
	private String weekDay;
	private int personMin;
	private int personMax;
	private String flightNo;
	private int preOrderDates;
	private String classType;
	//private String limitReturnFlight;
	private String carrierCode;

	public PolicyClass(){}

	public PolicyClass(ResultSet rs) throws SQLException {
		this.id = rs.getInt(COLUMN_ID);
		this.className = rs.getString(COLUMN_CLASS_NAME);
		this.routeType = rs.getString(COLUMN_ROUTE_TYPE);
		this.departure = rs.getString(COLUMN_DEPARTURE);
		this.destination = rs.getString(COLUMN_DESTINATION);
		this.price = rs.getInt(COLUMN_PRICE);
		this.rtOpen = rs.getString(COLUMN_RT_OPEN);
		this.cancelFee = rs.getInt(COLUMN_CANCEL_FEE);
		this.refundFee = rs.getInt(COLUMN_REFUND_FEE);
		this.policyNO = rs.getString(COLUMN_POLICY_NO);
		this.startDate = rs.getString(COLUMN_START_DATE);
		this.endDate = rs.getString(COLUMN_END_DATE);
		this.stayMin = rs.getInt(COLUMN_STAY_MIN);
		this.stayMax = rs.getInt(COLUMN_STAY_MAX);
		this.weekDay = rs.getString(COLUMN_WEEKDAY);
		this.personMin = rs.getInt(COLUMN_PERSON_MIN);
		this.personMax = rs.getInt(COLUMN_PERSON_MAX);
		this.flightNo = rs.getString(COLUMN_FLIGHT_NO);
		this.preOrderDates = rs.getInt(COLUMN_PRE_ORDER_DATES);
		this.classType = rs.getString(COLUMN_CLASS_TYPE);
		//this.limitReturnFlight = rs.getString(COLUMN_LIMIT_RETURN_FLIGHT);
		this.carrierCode = rs.getString(COLUMN_CARRIER_CODE);
	}

	/**
	 * @return the cancelFee
	 */
	public int getCancelFee() {
		return cancelFee;
	}

	/**
	 * @param cancelFee the cancelFee to set
	 */
	public void setCancelFee(int cancelFee) {
		this.cancelFee = cancelFee;
	}

	/**
	 * @return the className
	 */
	public String getClassName() {
		return className;
	}

	/**
	 * @param className the className to set
	 */
	public void setClassName(String className) {
		this.className = className;
	}

	/**
	 * @return the departure
	 */
	public String getDeparture() {
		return departure;
	}

	/**
	 * @param departure the departure to set
	 */
	public void setDeparture(String departure) {
		this.departure = departure;
	}

	/**
	 * @return the destination
	 */
	public String getDestination() {
		return destination;
	}

	/**
	 * @param destination the destination to set
	 */
	public void setDestination(String destination) {
		this.destination = destination;
	}

	/**
	 * @return the endDate
	 */
	public String getEndDate() {
		return endDate;
	}

	/**
	 * @param endDate the endDate to set
	 */
	public void setEndDate(String endDate) {
		this.endDate = endDate;
	}

	/**
	 * @return the flightNo
	 */
	public String getFlightNo() {
		return flightNo;
	}

	/**
	 * @param flightNo the flightNo to set
	 */
	public void setFlightNo(String flightNo) {
		this.flightNo = flightNo;
	}

	/**
	 * @return the id
	 */
	public int getId() {
		return id;
	}

	/**
	 * @param id the id to set
	 */
	public void setId(int id) {
		this.id = id;
	}

	/**
	 * @return the personMax
	 */
	public int getPersonMax() {
		return personMax;
	}

	/**
	 * @param personMax the personMax to set
	 */
	public void setPersonMax(int personMax) {
		this.personMax = personMax;
	}

	/**
	 * @return the personMin
	 */
	public int getPersonMin() {
		return personMin;
	}

	/**
	 * @param personMin the personMin to set
	 */
	public void setPersonMin(int personMin) {
		this.personMin = personMin;
	}

	/**
	 * @return the preOrderDates
	 */
	public int getPreOrderDates() {
		return preOrderDates;
	}

	/**
	 * @param preOrderDates the preOrderDates to set
	 */
	public void setPreOrderDates(int preOrderDates) {
		this.preOrderDates = preOrderDates;
	}

	/**
	 * @return the price
	 */
	public int getPrice() {
		return price;
	}

	/**
	 * @param price the price to set
	 */
	public void setPrice(int price) {
		this.price = price;
	}

	/**
	 * @return the refundFee
	 */
	public int getRefundFee() {
		return refundFee;
	}

	/**
	 * @param refundFee the refundFee to set
	 */
	public void setRefundFee(int refundFee) {
		this.refundFee = refundFee;
	}

	/**
	 * @return the rtOpen
	 */
	public String getRtOpen() {
		return rtOpen;
	}

	/**
	 * @param rtOpen the rtOpen to set
	 */
	public void setRtOpen(String rtOpen) {
		this.rtOpen = rtOpen;
	}

	/**
	 * @return the startDate
	 */
	public String getStartDate() {
		return startDate;
	}

	/**
	 * @param startDate the startDate to set
	 */
	public void setStartDate(String startDate) {
		this.startDate = startDate;
	}

	/**
	 * @return the stayMax
	 */
	public int getStayMax() {
		return stayMax;
	}

	/**
	 * @param stayMax the stayMax to set
	 */
	public void setStayMax(int stayMax) {
		this.stayMax = stayMax;
	}

	/**
	 * @return the stayMin
	 */
	public int getStayMin() {
		return stayMin;
	}

	/**
	 * @param stayMin the stayMin to set
	 */
	public void setStayMin(int stayMin) {
		this.stayMin = stayMin;
	}

	/**
	 * @return the weekDay
	 */
	public String getWeekDay() {
		return weekDay;
	}

	/**
	 * @param weekDay the weekDay to set
	 */
	public void setWeekDay(String weekDay) {
		this.weekDay = weekDay;
	}

	/**
	 * @return the classType
	 */
	public String getClassType() {
		return classType;
	}

	/**
	 * @param classType the classType to set
	 */
	public void setClassType(String classType) {
		this.classType = classType;
	}

	/**
	 * @return the carrierCode
	 */
	public String getCarrierCode() {
		return carrierCode;
	}

	/**
	 * @param carrierCode the carrierCode to set
	 */
	public void setCarrierCode(String carrierCode) {
		this.carrierCode = carrierCode;
	}

	/**
	 * @return the policyNO
	 */
	public String getPolicyNO() {
		return policyNO;
	}

	/**
	 * @param policyNO the policyNO to set
	 */
	public void setPolicyNO(String policyNO) {
		this.policyNO = policyNO;
	}

	/**
	 * @return the routeType
	 */
	public String getRouteType() {
		return routeType;
	}

	/**
	 * @param routeType the routeType to set
	 */
	public void setRouteType(String routeType) {
		this.routeType = routeType;
	}

}
